from sqlalchemy import Column
from sqlalchemy.sql.sqltypes import Integer, String, Text, TIMESTAMP
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()

class LandPublicityDetail(Base):
    __tablename__ = "TYC_M_LAND_PUBLICITY_DETAIL"
    ID = Column(String(255))
    LANDUSER_CLEAN = Column(String(4000))
    PUBLICATION_ORGANIZE = Column(String(255))
    CONTACT_PERSON = Column(String(255))
    LAND_LOCATION = Column(String(255))
    LAND_AREA = Column(String(255))
    REMARK = Column(String(500))
    PUBLIC_ANNOUNCEMENT_PERIOD = Column(String(255))
    LAND_NUM = Column(String(255))
    PROJECT_NAME = Column(String(255))
    CONTACT_NUMBER = Column(String(255))
    ELECTRONIC_MAIL = Column(String(255))
    ORGANIZE_LOCATION = Column(String(255))
    LAND_USEFULNESS = Column(String(255))
    FEEDBACK_METHOD = Column(String(1000))
    PUBLICATION_DATE = Column(String(255))
    CONTACT_ORGANIZE = Column(String(255))
    POSTAL_CODE = Column(String(255))

    ENTNAME = Column(String(100))
    PRIPID = Column(String(36))
    REGNO = Column(String(50))
    UNISCID = Column(String(18))
    CREATE_TIME = Column(TIMESTAMP)
    UPDATE_TIME = Column(TIMESTAMP)